From 722328f3b26f562a69b53817397d7d81693e3b59 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Tue, 11 Aug 2026 16:18:43 -0700 Subject: [PATCH] conversion: use NONE for A-record groom scans --- conversion/load_groom_scan_arec.sql | 7 ++++--- doc/src/tables/watches.m4 | 8 ++++---- 2 files changed, 8 insertions(+), 7 deletions(-) diff --git a/conversion/load_groom_scan_arec.sql b/conversion/load_groom_scan_arec.sql index f93336f..2d26939 100644 --- a/conversion/load_groom_scan_arec.sql +++ b/conversion/load_groom_scan_arec.sql @@ -37,11 +37,12 @@ BEGIN , groom_scan_arec.chimp_1 , groom_scan_arec.chimp_2 LOOP - -- Which watch belongs to the groom scan? + -- These feeding-station scans have no focal individual. Which no-focal + -- A-record watch belongs to the groom scan? SELECT watches.wid INTO related_wid FROM watches - WHERE watches.animid = 'UNK' + WHERE watches.animid = 'NONE' AND watches.date = this_gs.date AND watches.type = 'A'; @@ -60,7 +61,7 @@ BEGIN , type , notes) VALUES ( - 'UNK' + 'NONE' , related_commid , this_gs.date , 'A' diff --git a/doc/src/tables/watches.m4 b/doc/src/tables/watches.m4 index 6552bb6..93c4135 100644 --- a/doc/src/tables/watches.m4 +++ b/doc/src/tables/watches.m4 @@ -80,10 +80,10 @@ The |WATCHES.Type| categories are: When there is no related |ARRIVALS_A| row, when there are only related |EVENTS| rows with an |EVENTS|.\ |EVENTS.Behavior| value of ``sdb_groom_scan_a`` to record interval scans for grooming, the - expectation is that the individual recorded in the - |WATCHES.AnimID| column, will be ``sdb_unk``. - The system will generate a warning when when the |WATCHES.AnimID| - is not ``sdb_unk`` and there are related |EVENTS| rows with an + |WATCHES.AnimID| value is expected to be ``sdb_no_focal`` because + these scans have no focal individual. + The system will generate a warning when the |WATCHES.AnimID| + is not ``sdb_no_focal`` and there are related |EVENTS| rows with an |EVENTS|.\ |EVENTS.Behavior| of ``sdb_groom_scan_a``. The system expects, but does not require, that individuals recorded -- 2.34.1